The fourth part of the training SQL.
What you will see in this video:
- Create a column with an AUTO_INCREMENT option
- Create a column with default DEFAULT value
- Getting to know the WHERE conditional statement
- How to add rows to the table with the INSERT INTO statement
- How to edit a row in the table with the UPDATE statement
- How to edit all rows of the table at once with the UPDATE statement
- How to delete a row from the table with the DELETE FROM statement
- How to delete all rows of the table at once with the DELETE FROM statement
- How to delete the table itself and all its rows at once with the DROP TABLE statement